NOTE
1.19 MySQL show profile
1. What It Is 2. Usage 2.1. Enable 2.2. View Results 2.3. Analyze
This is a historical learning note and may contain outdated or incomplete understanding.
1. What It Is
show variables like 'profiling'+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| profiling | OFF |
+---------------+-------+2. Usage
2.1. Enable
set profiling=on;2.2. View Results
show profiles;2.3. Analyze
show profile cpu,block io for query 3;
Discussion
Sign in with GitHub to comment. Discussions are stored as GitHub Issues.View on GitHub